﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dbDataSet" targetNamespace="http://tempuri.org/dbDataSet.xsd" xmlns:mstns="http://tempuri.org/dbDataSet.xsd" xmlns="http://tempuri.org/dbDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="dbConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="dbConnectionString (Settings)" PropertyReference="ApplicationSettings.Editor.Properties.Settings.GlobalReference.Default.dbConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="web_classlinkdrugTableAdapter" GeneratorDataComponentClassName="web_classlinkdrugTableAdapter" Name="web_classlinkdrug" UserDataComponentName="web_classlinkdrugTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbConnectionString (Settings)" DbObjectName="web_classlinkdrug" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `web_classlinkdrug` WHERE ((`i_id` = ?) AND ((? = 1 AND `i_drugclass_id` IS NULL) OR (`i_drugclass_id` = ?)) AND ((? = 1 AND `i_web_pi` IS NULL) OR (`i_web_pi` = ?)) AND ((? = 1 AND `i_web_ei` IS NULL) OR (`i_web_ei` = ?)) AND ((? = 1 AND `i_web_dr` IS NULL) OR (`i_web_dr` = ?)) AND ((? = 1 AND `i_generic_drug` IS NULL) OR (`i_generic_drug` = ?)) AND ((? = 1 AND `i_other_name` IS NULL) OR (`i_other_name` = ?)) AND ((? = 1 AND `i_web_de` IS NULL) OR (`i_web_de` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_drugclass_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_drugclass_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_drugclass_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_drugclass_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_dr" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_dr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_dr" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_dr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_generic_drug" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_generic_drug" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_generic_drug" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_generic_drug" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_other_name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_other_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_other_name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_other_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `web_classlinkdrug` (`i_drugclass_id`, `i_web_pi`, `i_web_ei`, `i_web_dr`, `i_generic_drug`, `i_other_name`, `i_web_de`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_drugclass_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_drugclass_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_dr" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_dr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_generic_drug" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_generic_drug" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_other_name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_other_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT i_id, i_drugclass_id, i_web_pi, i_web_ei, i_web_dr, i_generic_drug, i_other_name, i_web_de FROM web_classlinkdrug</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `web_classlinkdrug` SET `i_drugclass_id` = ?, `i_web_pi` = ?, `i_web_ei` = ?, `i_web_dr` = ?, `i_generic_drug` = ?, `i_other_name` = ?, `i_web_de` = ? WHERE ((`i_id` = ?) AND ((? = 1 AND `i_drugclass_id` IS NULL) OR (`i_drugclass_id` = ?)) AND ((? = 1 AND `i_web_pi` IS NULL) OR (`i_web_pi` = ?)) AND ((? = 1 AND `i_web_ei` IS NULL) OR (`i_web_ei` = ?)) AND ((? = 1 AND `i_web_dr` IS NULL) OR (`i_web_dr` = ?)) AND ((? = 1 AND `i_generic_drug` IS NULL) OR (`i_generic_drug` = ?)) AND ((? = 1 AND `i_other_name` IS NULL) OR (`i_other_name` = ?)) AND ((? = 1 AND `i_web_de` IS NULL) OR (`i_web_de` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_drugclass_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_drugclass_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_dr" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_dr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_generic_drug" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_generic_drug" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_other_name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_other_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_drugclass_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_drugclass_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_drugclass_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_drugclass_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_dr" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_dr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_dr" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_dr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_generic_drug" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_generic_drug" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_generic_drug" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_generic_drug" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_other_name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_other_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_other_name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_other_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="i_id" DataSetColumn="i_id" />
              <Mapping SourceColumn="i_drugclass_id" DataSetColumn="i_drugclass_id" />
              <Mapping SourceColumn="i_web_pi" DataSetColumn="i_web_pi" />
              <Mapping SourceColumn="i_web_ei" DataSetColumn="i_web_ei" />
              <Mapping SourceColumn="i_web_dr" DataSetColumn="i_web_dr" />
              <Mapping SourceColumn="i_generic_drug" DataSetColumn="i_generic_drug" />
              <Mapping SourceColumn="i_other_name" DataSetColumn="i_other_name" />
              <Mapping SourceColumn="i_web_de" DataSetColumn="i_web_de" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="web_drugTableAdapter" GeneratorDataComponentClassName="web_drugTableAdapter" Name="web_drug" UserDataComponentName="web_drugTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbConnectionString (Settings)" DbObjectName="web_drug" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `web_drug` WHERE ((`i_id` = ?) AND ((? = 1 AND `i_generic_drug` IS NULL) OR (`i_generic_drug` = ?)) AND ((? = 1 AND `i_other_name` IS NULL) OR (`i_other_name` = ?)) AND ((? = 1 AND `c_name` IS NULL) OR (`c_name` = ?)) AND ((? = 1 AND `c_search_code` IS NULL) OR (`c_search_code` = ?)) AND ((? = 1 AND `c_firstcode` IS NULL) OR (`c_firstcode` = ?)) AND ((? = 1 AND `i_sortcode` IS NULL) OR (`i_sortcode` = ?)) AND ((? = 1 AND `i_name_type` IS NULL) OR (`i_name_type` = ?)) AND ((? = 1 AND `c_name_type` IS NULL) OR (`c_name_type` = ?)) AND ((? = 1 AND `i_dfmk` IS NULL) OR (`i_dfmk` = ?)) AND ((? = 1 AND `i_othmk` IS NULL) OR (`i_othmk` = ?)) AND ((? = 1 AND `i_cnmk` IS NULL) OR (`i_cnmk` = ?)) AND ((? = 1 AND `i_is_solvent` IS NULL) OR (`i_is_solvent` = ?)) AND ((? = 1 AND `i_pi_pub` IS NULL) OR (`i_pi_pub` = ?)) AND ((? = 1 AND `i_pi_dose` IS NULL) OR (`i_pi_dose` = ?)) AND ((? = 1 AND `i_bnmk` IS NULL) OR (`i_bnmk` = ?)) AND ((? = 1 AND `i_web_de` IS NULL) OR (`i_web_de` = ?)) AND ((? = 1 AND `i_web_in` IS NULL) OR (`i_web_in` = ?)) AND ((? = 1 AND `i_web_pi` IS NULL) OR (`i_web_pi` = ?)) AND ((? = 1 AND `i_web_ei` IS NULL) OR (`i_web_ei` = ?)) AND ((? = 1 AND `i_web_AZ` IS NULL) OR (`i_web_AZ` = ?)) AND ((? = 1 AND `i_web_olf` IS NULL) OR (`i_web_olf` = ?)) AND ((? = 1 AND `i_dr_id` IS NULL) OR (`i_dr_id` = ?)) AND ((? = 1 AND `i_web_pe` IS NULL) OR (`i_web_pe` = ?)) AND ((? = 1 AND `i_web_iv` IS NULL) OR (`i_web_iv` = ?)) AND ((? = 1 AND `i_name_len` IS NULL) OR (`i_name_len` = ?)) AND ((? = 1 AND `1` IS NULL) OR (`1` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_generic_drug" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_generic_drug" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_generic_drug" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_generic_drug" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_other_name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_other_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_other_name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_other_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_search_code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_search_code" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_search_code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_search_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_firstcode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_firstcode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_firstcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_firstcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_sortcode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_sortcode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_sortcode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_sortcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_name_type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_name_type" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_name_type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_name_type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_name_type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_name_type" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_name_type" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_name_type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_dfmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_dfmk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_dfmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_dfmk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_othmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_othmk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_othmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_othmk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_cnmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_cnmk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_cnmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_cnmk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_is_solvent" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_is_solvent" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_is_solvent" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_is_solvent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_pi_pub" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_pi_pub" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_pi_pub" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_pi_pub" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_pi_dose" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_pi_dose" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_pi_dose" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_pi_dose" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_bnmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_bnmk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_bnmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_bnmk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_in" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_in" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_in" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_in" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_AZ" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_AZ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_AZ" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_AZ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_olf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_olf" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_olf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_olf" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_dr_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_dr_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_dr_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_dr_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_pe" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_pe" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_iv" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_iv" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_iv" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_iv" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_name_len" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_name_len" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_name_len" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_name_len" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="1" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `web_drug` (`i_generic_drug`, `i_other_name`, `c_name`, `c_search_code`, `c_firstcode`, `i_sortcode`, `i_name_type`, `c_name_type`, `i_dfmk`, `i_othmk`, `i_cnmk`, `i_is_solvent`, `i_pi_pub`, `i_pi_dose`, `i_bnmk`, `i_web_de`, `i_web_in`, `i_web_pi`, `i_web_ei`, `i_web_AZ`, `i_web_olf`, `i_dr_id`, `i_web_pe`, `i_web_iv`, `i_name_len`, `1`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_generic_drug" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_generic_drug" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_other_name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_other_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_search_code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_search_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_firstcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_firstcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_sortcode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_sortcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_name_type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_name_type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_name_type" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_name_type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_dfmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_dfmk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_othmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_othmk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_cnmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_cnmk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_is_solvent" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_is_solvent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_pi_pub" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_pi_pub" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_pi_dose" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_pi_dose" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_bnmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_bnmk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_in" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_in" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_AZ" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_AZ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_olf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_olf" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_dr_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_dr_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_pe" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_iv" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_iv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_name_len" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_name_len" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT i_id, i_generic_drug, i_other_name, c_name, c_search_code, c_firstcode, i_sortcode, i_name_type, c_name_type, i_dfmk, i_othmk, i_cnmk, i_is_solvent, i_pi_pub, i_pi_dose, i_bnmk, i_web_de, i_web_in, i_web_pi, i_web_ei, i_web_AZ, i_web_olf, i_dr_id, i_web_pe, i_web_iv, i_name_len, [1] FROM web_drug</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `web_drug` SET `i_generic_drug` = ?, `i_other_name` = ?, `c_name` = ?, `c_search_code` = ?, `c_firstcode` = ?, `i_sortcode` = ?, `i_name_type` = ?, `c_name_type` = ?, `i_dfmk` = ?, `i_othmk` = ?, `i_cnmk` = ?, `i_is_solvent` = ?, `i_pi_pub` = ?, `i_pi_dose` = ?, `i_bnmk` = ?, `i_web_de` = ?, `i_web_in` = ?, `i_web_pi` = ?, `i_web_ei` = ?, `i_web_AZ` = ?, `i_web_olf` = ?, `i_dr_id` = ?, `i_web_pe` = ?, `i_web_iv` = ?, `i_name_len` = ?, `1` = ? WHERE ((`i_id` = ?) AND ((? = 1 AND `i_generic_drug` IS NULL) OR (`i_generic_drug` = ?)) AND ((? = 1 AND `i_other_name` IS NULL) OR (`i_other_name` = ?)) AND ((? = 1 AND `c_name` IS NULL) OR (`c_name` = ?)) AND ((? = 1 AND `c_search_code` IS NULL) OR (`c_search_code` = ?)) AND ((? = 1 AND `c_firstcode` IS NULL) OR (`c_firstcode` = ?)) AND ((? = 1 AND `i_sortcode` IS NULL) OR (`i_sortcode` = ?)) AND ((? = 1 AND `i_name_type` IS NULL) OR (`i_name_type` = ?)) AND ((? = 1 AND `c_name_type` IS NULL) OR (`c_name_type` = ?)) AND ((? = 1 AND `i_dfmk` IS NULL) OR (`i_dfmk` = ?)) AND ((? = 1 AND `i_othmk` IS NULL) OR (`i_othmk` = ?)) AND ((? = 1 AND `i_cnmk` IS NULL) OR (`i_cnmk` = ?)) AND ((? = 1 AND `i_is_solvent` IS NULL) OR (`i_is_solvent` = ?)) AND ((? = 1 AND `i_pi_pub` IS NULL) OR (`i_pi_pub` = ?)) AND ((? = 1 AND `i_pi_dose` IS NULL) OR (`i_pi_dose` = ?)) AND ((? = 1 AND `i_bnmk` IS NULL) OR (`i_bnmk` = ?)) AND ((? = 1 AND `i_web_de` IS NULL) OR (`i_web_de` = ?)) AND ((? = 1 AND `i_web_in` IS NULL) OR (`i_web_in` = ?)) AND ((? = 1 AND `i_web_pi` IS NULL) OR (`i_web_pi` = ?)) AND ((? = 1 AND `i_web_ei` IS NULL) OR (`i_web_ei` = ?)) AND ((? = 1 AND `i_web_AZ` IS NULL) OR (`i_web_AZ` = ?)) AND ((? = 1 AND `i_web_olf` IS NULL) OR (`i_web_olf` = ?)) AND ((? = 1 AND `i_dr_id` IS NULL) OR (`i_dr_id` = ?)) AND ((? = 1 AND `i_web_pe` IS NULL) OR (`i_web_pe` = ?)) AND ((? = 1 AND `i_web_iv` IS NULL) OR (`i_web_iv` = ?)) AND ((? = 1 AND `i_name_len` IS NULL) OR (`i_name_len` = ?)) AND ((? = 1 AND `1` IS NULL) OR (`1` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_generic_drug" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_generic_drug" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_other_name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_other_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_search_code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_search_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_firstcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_firstcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_sortcode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_sortcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_name_type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_name_type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_name_type" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_name_type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_dfmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_dfmk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_othmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_othmk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_cnmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_cnmk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_is_solvent" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_is_solvent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_pi_pub" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_pi_pub" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_pi_dose" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_pi_dose" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_bnmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_bnmk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_in" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_in" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_AZ" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_AZ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_olf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_olf" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_dr_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_dr_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_pe" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_iv" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_iv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_name_len" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_name_len" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_generic_drug" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_generic_drug" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_generic_drug" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_generic_drug" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_other_name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_other_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_other_name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_other_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_search_code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_search_code" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_search_code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_search_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_firstcode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_firstcode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_firstcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_firstcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_sortcode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_sortcode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_sortcode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_sortcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_name_type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_name_type" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_name_type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_name_type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_name_type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_name_type" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_name_type" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_name_type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_dfmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_dfmk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_dfmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_dfmk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_othmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_othmk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_othmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_othmk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_cnmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_cnmk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_cnmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_cnmk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_is_solvent" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_is_solvent" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_is_solvent" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_is_solvent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_pi_pub" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_pi_pub" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_pi_pub" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_pi_pub" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_pi_dose" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_pi_dose" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_pi_dose" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_pi_dose" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_bnmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_bnmk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_bnmk" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_bnmk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_in" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_in" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_in" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_in" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_AZ" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_AZ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_AZ" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_AZ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_olf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_olf" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_olf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_olf" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_dr_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_dr_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_dr_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_dr_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_pe" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_pe" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_iv" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_iv" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_iv" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_iv" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_name_len" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_name_len" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_name_len" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_name_len" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="1" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="i_id" DataSetColumn="i_id" />
              <Mapping SourceColumn="i_generic_drug" DataSetColumn="i_generic_drug" />
              <Mapping SourceColumn="i_other_name" DataSetColumn="i_other_name" />
              <Mapping SourceColumn="c_name" DataSetColumn="c_name" />
              <Mapping SourceColumn="c_search_code" DataSetColumn="c_search_code" />
              <Mapping SourceColumn="c_firstcode" DataSetColumn="c_firstcode" />
              <Mapping SourceColumn="i_sortcode" DataSetColumn="i_sortcode" />
              <Mapping SourceColumn="i_name_type" DataSetColumn="i_name_type" />
              <Mapping SourceColumn="c_name_type" DataSetColumn="c_name_type" />
              <Mapping SourceColumn="i_dfmk" DataSetColumn="i_dfmk" />
              <Mapping SourceColumn="i_othmk" DataSetColumn="i_othmk" />
              <Mapping SourceColumn="i_cnmk" DataSetColumn="i_cnmk" />
              <Mapping SourceColumn="i_is_solvent" DataSetColumn="i_is_solvent" />
              <Mapping SourceColumn="i_pi_pub" DataSetColumn="i_pi_pub" />
              <Mapping SourceColumn="i_pi_dose" DataSetColumn="i_pi_dose" />
              <Mapping SourceColumn="i_bnmk" DataSetColumn="i_bnmk" />
              <Mapping SourceColumn="i_web_de" DataSetColumn="i_web_de" />
              <Mapping SourceColumn="i_web_in" DataSetColumn="i_web_in" />
              <Mapping SourceColumn="i_web_pi" DataSetColumn="i_web_pi" />
              <Mapping SourceColumn="i_web_ei" DataSetColumn="i_web_ei" />
              <Mapping SourceColumn="i_web_AZ" DataSetColumn="i_web_AZ" />
              <Mapping SourceColumn="i_web_olf" DataSetColumn="i_web_olf" />
              <Mapping SourceColumn="i_dr_id" DataSetColumn="i_dr_id" />
              <Mapping SourceColumn="i_web_pe" DataSetColumn="i_web_pe" />
              <Mapping SourceColumn="i_web_iv" DataSetColumn="i_web_iv" />
              <Mapping SourceColumn="i_name_len" DataSetColumn="i_name_len" />
              <Mapping SourceColumn="1" DataSetColumn="1" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="web_drugclassTableAdapter" GeneratorDataComponentClassName="web_drugclassTableAdapter" Name="web_drugclass" UserDataComponentName="web_drugclassTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbConnectionString (Settings)" DbObjectName="web_drugclass" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `web_drugclass` WHERE ((`i_id` = ?) AND ((? = 1 AND `i_drugclass_id` IS NULL) OR (`i_drugclass_id` = ?)) AND ((? = 1 AND `c_title` IS NULL) OR (`c_title` = ?)) AND ((? = 1 AND `i_parentid` IS NULL) OR (`i_parentid` = ?)) AND ((? = 1 AND `i_isleaf` IS NULL) OR (`i_isleaf` = ?)) AND ((? = 1 AND `c_fullpath` IS NULL) OR (`c_fullpath` = ?)) AND ((? = 1 AND `i_isxiyao` IS NULL) OR (`i_isxiyao` = ?)) AND ((? = 1 AND `c_sortcode` IS NULL) OR (`c_sortcode` = ?)) AND ((? = 1 AND `i_web_pi` IS NULL) OR (`i_web_pi` = ?)) AND ((? = 1 AND `i_web_ei` IS NULL) OR (`i_web_ei` = ?)) AND ((? = 1 AND `i_web_dr` IS NULL) OR (`i_web_dr` = ?)) AND ((? = 1 AND `i_web_de` IS NULL) OR (`i_web_de` = ?)) AND ((? = 1 AND `c_class1` IS NULL) OR (`c_class1` = ?)) AND ((? = 1 AND `c_class2` IS NULL) OR (`c_class2` = ?)) AND ((? = 1 AND `c_class3` IS NULL) OR (`c_class3` = ?)) AND ((? = 1 AND `c_class4` IS NULL) OR (`c_class4` = ?)) AND ((? = 1 AND `i_parentid_1` IS NULL) OR (`i_parentid_1` = ?)) AND ((? = 1 AND `i_parentid_2` IS NULL) OR (`i_parentid_2` = ?)) AND ((? = 1 AND `i_parentid_3` IS NULL) OR (`i_parentid_3` = ?)) AND ((? = 1 AND `i_parentid_4` IS NULL) OR (`i_parentid_4` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_drugclass_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_drugclass_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_drugclass_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_drugclass_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_title" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_title" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_parentid" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_parentid" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_isleaf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_isleaf" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_isleaf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_isleaf" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_fullpath" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_fullpath" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_fullpath" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_fullpath" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_isxiyao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_isxiyao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_isxiyao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_isxiyao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_sortcode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_sortcode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_sortcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_sortcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_dr" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_dr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_dr" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_dr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_class1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_class1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_class1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_class1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_class2" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_class2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_class2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_class2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_class3" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_class3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_class3" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_class3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_class4" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_class4" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_class4" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_class4" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_parentid_1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_parentid_1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_parentid_2" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_parentid_2" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_parentid_3" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_parentid_3" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_parentid_4" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_4" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_parentid_4" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_4" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `web_drugclass` (`i_drugclass_id`, `c_title`, `i_parentid`, `i_isleaf`, `c_fullpath`, `i_isxiyao`, `c_sortcode`, `i_web_pi`, `i_web_ei`, `i_web_dr`, `i_web_de`, `c_class1`, `c_class2`, `c_class3`, `c_class4`, `i_parentid_1`, `i_parentid_2`, `i_parentid_3`, `i_parentid_4`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_drugclass_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_drugclass_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_title" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_parentid" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_isleaf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_isleaf" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_fullpath" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_fullpath" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_isxiyao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_isxiyao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_sortcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_sortcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_dr" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_dr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_class1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_class1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_class2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_class2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_class3" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_class3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_class4" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_class4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_parentid_1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_parentid_2" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_parentid_3" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_parentid_4" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT i_id, i_drugclass_id, c_title, i_parentid, i_isleaf, c_fullpath, i_isxiyao, c_sortcode, 
      i_web_pi, i_web_ei, i_web_dr, i_web_de, c_class1, c_class2, c_class3, c_class4, 
      i_parentid_1, i_parentid_2, i_parentid_3, i_parentid_4
FROM web_drugclass
ORDER BY c_sortcode</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `web_drugclass` SET `i_drugclass_id` = ?, `c_title` = ?, `i_parentid` = ?, `i_isleaf` = ?, `c_fullpath` = ?, `i_isxiyao` = ?, `c_sortcode` = ?, `i_web_pi` = ?, `i_web_ei` = ?, `i_web_dr` = ?, `i_web_de` = ?, `c_class1` = ?, `c_class2` = ?, `c_class3` = ?, `c_class4` = ?, `i_parentid_1` = ?, `i_parentid_2` = ?, `i_parentid_3` = ?, `i_parentid_4` = ? WHERE ((`i_id` = ?) AND ((? = 1 AND `i_drugclass_id` IS NULL) OR (`i_drugclass_id` = ?)) AND ((? = 1 AND `c_title` IS NULL) OR (`c_title` = ?)) AND ((? = 1 AND `i_parentid` IS NULL) OR (`i_parentid` = ?)) AND ((? = 1 AND `i_isleaf` IS NULL) OR (`i_isleaf` = ?)) AND ((? = 1 AND `c_fullpath` IS NULL) OR (`c_fullpath` = ?)) AND ((? = 1 AND `i_isxiyao` IS NULL) OR (`i_isxiyao` = ?)) AND ((? = 1 AND `c_sortcode` IS NULL) OR (`c_sortcode` = ?)) AND ((? = 1 AND `i_web_pi` IS NULL) OR (`i_web_pi` = ?)) AND ((? = 1 AND `i_web_ei` IS NULL) OR (`i_web_ei` = ?)) AND ((? = 1 AND `i_web_dr` IS NULL) OR (`i_web_dr` = ?)) AND ((? = 1 AND `i_web_de` IS NULL) OR (`i_web_de` = ?)) AND ((? = 1 AND `c_class1` IS NULL) OR (`c_class1` = ?)) AND ((? = 1 AND `c_class2` IS NULL) OR (`c_class2` = ?)) AND ((? = 1 AND `c_class3` IS NULL) OR (`c_class3` = ?)) AND ((? = 1 AND `c_class4` IS NULL) OR (`c_class4` = ?)) AND ((? = 1 AND `i_parentid_1` IS NULL) OR (`i_parentid_1` = ?)) AND ((? = 1 AND `i_parentid_2` IS NULL) OR (`i_parentid_2` = ?)) AND ((? = 1 AND `i_parentid_3` IS NULL) OR (`i_parentid_3` = ?)) AND ((? = 1 AND `i_parentid_4` IS NULL) OR (`i_parentid_4` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_drugclass_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_drugclass_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_title" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_parentid" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_isleaf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_isleaf" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_fullpath" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_fullpath" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_isxiyao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_isxiyao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_sortcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_sortcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_dr" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_dr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_class1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_class1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_class2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_class2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_class3" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_class3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="c_class4" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_class4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_parentid_1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_parentid_2" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_parentid_3" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="i_parentid_4" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_drugclass_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_drugclass_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_drugclass_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_drugclass_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_title" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_title" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_parentid" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_parentid" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_isleaf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_isleaf" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_isleaf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_isleaf" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_fullpath" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_fullpath" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_fullpath" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_fullpath" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_isxiyao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_isxiyao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_isxiyao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_isxiyao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_sortcode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_sortcode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_sortcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_sortcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_pi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_pi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_ei" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_ei" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_dr" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_dr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_dr" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_dr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_web_de" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_web_de" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_class1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_class1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_class1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_class1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_class2" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_class2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_class2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_class2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_class3" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_class3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_class3" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_class3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_c_class4" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="c_class4" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_c_class4" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="c_class4" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_parentid_1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_parentid_1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_parentid_2" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_parentid_2" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_parentid_3" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_parentid_3" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_i_parentid_4" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_4" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_i_parentid_4" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="i_parentid_4" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="i_id" DataSetColumn="i_id" />
              <Mapping SourceColumn="i_drugclass_id" DataSetColumn="i_drugclass_id" />
              <Mapping SourceColumn="c_title" DataSetColumn="c_title" />
              <Mapping SourceColumn="i_parentid" DataSetColumn="i_parentid" />
              <Mapping SourceColumn="i_isleaf" DataSetColumn="i_isleaf" />
              <Mapping SourceColumn="c_fullpath" DataSetColumn="c_fullpath" />
              <Mapping SourceColumn="i_isxiyao" DataSetColumn="i_isxiyao" />
              <Mapping SourceColumn="c_sortcode" DataSetColumn="c_sortcode" />
              <Mapping SourceColumn="i_web_pi" DataSetColumn="i_web_pi" />
              <Mapping SourceColumn="i_web_ei" DataSetColumn="i_web_ei" />
              <Mapping SourceColumn="i_web_dr" DataSetColumn="i_web_dr" />
              <Mapping SourceColumn="i_web_de" DataSetColumn="i_web_de" />
              <Mapping SourceColumn="c_class1" DataSetColumn="c_class1" />
              <Mapping SourceColumn="c_class2" DataSetColumn="c_class2" />
              <Mapping SourceColumn="c_class3" DataSetColumn="c_class3" />
              <Mapping SourceColumn="c_class4" DataSetColumn="c_class4" />
              <Mapping SourceColumn="i_parentid_1" DataSetColumn="i_parentid_1" />
              <Mapping SourceColumn="i_parentid_2" DataSetColumn="i_parentid_2" />
              <Mapping SourceColumn="i_parentid_3" DataSetColumn="i_parentid_3" />
              <Mapping SourceColumn="i_parentid_4" DataSetColumn="i_parentid_4" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="dbConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByParent" GetMethodModifier="Public" GetMethodName="GetDataByParent" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByParent" UserSourceName="GetDataByParent">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT i_id, i_drugclass_id, c_title, i_parentid, i_isleaf, c_fullpath, i_isxiyao, c_sortcode, 
      i_web_pi, i_web_ei, i_web_dr, i_web_de, c_class1, c_class2, c_class3, c_class4, 
      i_parentid_1, i_parentid_2, i_parentid_3, i_parentid_4
FROM web_drugclass
where i_parentid=@parentid
ORDER BY c_sortcode</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@parentid" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="web_drugclass" msprop:Generator_TableClassName="web_drugclassDataTable" msprop:Generator_TableVarName="tableweb_drugclass" msprop:Generator_TablePropName="web_drugclass" msprop:Generator_RowDeletingName="web_drugclassRowDeleting" msprop:Generator_UserTableName="web_drugclass" msprop:Generator_RowChangingName="web_drugclassRowChanging" msprop:Generator_RowEvHandlerName="web_drugclassRowChangeEventHandler" msprop:Generator_RowDeletedName="web_drugclassRowDeleted" msprop:Generator_RowEvArgName="web_drugclassRowChangeEvent" msprop:Generator_RowChangedName="web_drugclassRowChanged" msprop:Generator_RowClassName="web_drugclassRow">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="i_id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columni_id" msprop:Generator_ColumnPropNameInRow="i_id" msprop:Generator_ColumnPropNameInTable="i_idColumn" msprop:Generator_UserColumnName="i_id" type="xs:int" />
        <xs:element name="i_drugclass_id" msprop:Generator_ColumnVarNameInTable="columni_drugclass_id" msprop:Generator_ColumnPropNameInRow="i_drugclass_id" msprop:Generator_ColumnPropNameInTable="i_drugclass_idColumn" msprop:Generator_UserColumnName="i_drugclass_id" type="xs:int" minOccurs="0" />
        <xs:element name="c_title" msprop:Generator_ColumnVarNameInTable="columnc_title" msprop:Generator_ColumnPropNameInRow="c_title" msprop:Generator_ColumnPropNameInTable="c_titleColumn" msprop:Generator_UserColumnName="c_title" minOccurs="0">
          <xs:simpleType>
            <xs:restriction base="xs:string">
              <xs:maxLength value="255" />
            </xs:restriction>
          </xs:simpleType>
        </xs:element>
        <xs:element name="i_parentid" msprop:Generator_ColumnVarNameInTable="columni_parentid" msprop:Generator_ColumnPropNameInRow="i_parentid" msprop:Generator_ColumnPropNameInTable="i_parentidColumn" msprop:Generator_UserColumnName="i_parentid" type="xs:int" minOccurs="0" />
        <xs:element name="i_isleaf" msprop:Generator_ColumnVarNameInTable="columni_isleaf" msprop:Generator_ColumnPropNameInRow="i_isleaf" msprop:Generator_ColumnPropNameInTable="i_isleafColumn" msprop:Generator_UserColumnName="i_isleaf" type="xs:int" minOccurs="0" />
        <xs:element name="c_fullpath" msprop:Generator_ColumnVarNameInTable="columnc_fullpath" msprop:Generator_ColumnPropNameInRow="c_fullpath" msprop:Generator_ColumnPropNameInTable="c_fullpathColumn" msprop:Generator_UserColumnName="c_fullpath" minOccurs="0">
          <xs:simpleType>
            <xs:restriction base="xs:string">
              <xs:maxLength value="255" />
            </xs:restriction>
          </xs:simpleType>
        </xs:element>
        <xs:element name="i_isxiyao" msprop:Generator_ColumnVarNameInTable="columni_isxiyao" msprop:Generator_ColumnPropNameInRow="i_isxiyao" msprop:Generator_ColumnPropNameInTable="i_isxiyaoColumn" msprop:Generator_UserColumnName="i_isxiyao" type="xs:int" minOccurs="0" />
        <xs:element name="c_sortcode" msprop:Generator_ColumnVarNameInTable="columnc_sortcode" msprop:Generator_ColumnPropNameInRow="c_sortcode" msprop:Generator_ColumnPropNameInTable="c_sortcodeColumn" msprop:Generator_UserColumnName="c_sortcode" minOccurs="0">
          <xs:simpleType>
            <xs:restriction base="xs:string">
              <xs:maxLength value="32" />
            </xs:restriction>
          </xs:simpleType>
        </xs:element>
        <xs:element name="i_web_pi" msprop:Generator_ColumnVarNameInTable="columni_web_pi" msprop:Generator_ColumnPropNameInRow="i_web_pi" msprop:Generator_ColumnPropNameInTable="i_web_piColumn" msprop:Generator_UserColumnName="i_web_pi" type="xs:int" minOccurs="0" />
        <xs:element name="i_web_ei" msprop:Generator_ColumnVarNameInTable="columni_web_ei" msprop:Generator_ColumnPropNameInRow="i_web_ei" msprop:Generator_ColumnPropNameInTable="i_web_eiColumn" msprop:Generator_UserColumnName="i_web_ei" type="xs:int" minOccurs="0" />
        <xs:element name="i_web_dr" msprop:Generator_ColumnVarNameInTable="columni_web_dr" msprop:Generator_ColumnPropNameInRow="i_web_dr" msprop:Generator_ColumnPropNameInTable="i_web_drColumn" msprop:Generator_UserColumnName="i_web_dr" type="xs:int" minOccurs="0" />
        <xs:element name="i_web_de" msprop:Generator_ColumnVarNameInTable="columni_web_de" msprop:Generator_ColumnPropNameInRow="i_web_de" msprop:Generator_ColumnPropNameInTable="i_web_deColumn" msprop:Generator_UserColumnName="i_web_de" type="xs:int" minOccurs="0" />
        <xs:element name="c_class1" msprop:Generator_ColumnVarNameInTable="columnc_class1" msprop:Generator_ColumnPropNameInRow="c_class1" msprop:Generator_ColumnPropNameInTable="c_class1Column" msprop:Generator_UserColumnName="c_class1" minOccurs="0">
          <xs:simpleType>
            <xs:restriction base="xs:string">
              <xs:maxLength value="50" />
            </xs:restriction>
          </xs:simpleType>
        </xs:element>
        <xs:element name="c_class2" msprop:Generator_ColumnVarNameInTable="columnc_class2" msprop:Generator_ColumnPropNameInRow="c_class2" msprop:Generator_ColumnPropNameInTable="c_class2Column" msprop:Generator_UserColumnName="c_class2" minOccurs="0">
          <xs:simpleType>
            <xs:restriction base="xs:string">
              <xs:maxLength value="50" />
            </xs:restriction>
          </xs:simpleType>
        </xs:element>
        <xs:element name="c_class3" msprop:Generator_ColumnVarNameInTable="columnc_class3" msprop:Generator_ColumnPropNameInRow="c_class3" msprop:Generator_ColumnPropNameInTable="c_class3Column" msprop:Generator_UserColumnName="c_class3" minOccurs="0">
          <xs:simpleType>
            <xs:restriction base="xs:string">
              <xs:maxLength value="50" />
            </xs:restriction>
          </xs:simpleType>
        </xs:element>
        <xs:element name="c_class4" msprop:Generator_ColumnVarNameInTable="columnc_class4" msprop:Generator_ColumnPropNameInRow="c_class4" msprop:Generator_ColumnPropNameInTable="c_class4Column" msprop:Generator_UserColumnName="c_class4" minOccurs="0">
          <xs:simpleType>
            <xs:restriction base="xs:string">
              <xs:maxLength value="50" />
            </xs:restriction>
          </xs:simpleType>
        </xs:element>
        <xs:element name="i_parentid_1" msprop:Generator_ColumnVarNameInTable="columni_parentid_1" msprop:Generator_ColumnPropNameInRow="i_parentid_1" msprop:Generator_ColumnPropNameInTable="i_parentid_1Column" msprop:Generator_UserColumnName="i_parentid_1" type="xs:int" minOccurs="0" />
        <xs:element name="i_parentid_2" msprop:Generator_ColumnVarNameInTable="columni_parentid_2" msprop:Generator_ColumnPropNameInRow="i_parentid_2" msprop:Generator_ColumnPropNameInTable="i_parentid_2Column" msprop:Generator_UserColumnName="i_parentid_2" type="xs:int" minOccurs="0" />
        <xs:element name="i_parentid_3" msprop:Generator_ColumnVarNameInTable="columni_parentid_3" msprop:Generator_ColumnPropNameInRow="i_parentid_3" msprop:Generator_ColumnPropNameInTable="i_parentid_3Column" msprop:Generator_UserColumnName="i_parentid_3" type="xs:int" minOccurs="0" />
        <xs:element name="i_parentid_4" msprop:Generator_ColumnVarNameInTable="columni_parentid_4" msprop:Generator_ColumnPropNameInRow="i_parentid_4" msprop:Generator_ColumnPropNameInTable="i_parentid_4Column" msprop:Generator_UserColumnName="i_parentid_4" type="xs:int" minOccurs="0" />
        <xs:element ref="web_drugclass" minOccurs="0" maxOccurs="unbounded">
          <xs:annotation>
            <xs:appinfo>
              <msdata:Relationship name="web_drugclass_web_drugclass" msdata:parent="web_drugclass" msdata:child="web_drugclass" msdata:parentkey="i_id" msdata:childkey="i_parentid" msprop:Generator_UserChildTable="web_drugclass" msprop:Generator_ChildPropName="Getweb_drugclassRows" msprop:Generator_UserParentTable="web_drugclass" msprop:Generator_UserRelationName="web_drugclass_web_drugclass" msprop:Generator_RelationVarName="relationweb_drugclass_web_drugclass" msprop:Generator_ParentPropName="web_drugclassRowParent" />
            </xs:appinfo>
          </xs:annotation>
        </xs:element>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="dbDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="dbDataSet" msprop:Generator_UserDSName="dbDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element ref="web_drugclass" />
        <xs:element name="web_classlinkdrug" msprop:Generator_TableClassName="web_classlinkdrugDataTable" msprop:Generator_TableVarName="tableweb_classlinkdrug" msprop:Generator_TablePropName="web_classlinkdrug" msprop:Generator_RowDeletingName="web_classlinkdrugRowDeleting" msprop:Generator_UserTableName="web_classlinkdrug" msprop:Generator_RowChangingName="web_classlinkdrugRowChanging" msprop:Generator_RowEvHandlerName="web_classlinkdrugRowChangeEventHandler" msprop:Generator_RowDeletedName="web_classlinkdrugRowDeleted" msprop:Generator_RowEvArgName="web_classlinkdrugRowChangeEvent" msprop:Generator_RowChangedName="web_classlinkdrugRowChanged" msprop:Generator_RowClassName="web_classlinkdrugRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="i_id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columni_id" msprop:Generator_ColumnPropNameInRow="i_id" msprop:Generator_ColumnPropNameInTable="i_idColumn" msprop:Generator_UserColumnName="i_id" type="xs:int" />
              <xs:element name="i_drugclass_id" msprop:Generator_ColumnVarNameInTable="columni_drugclass_id" msprop:Generator_ColumnPropNameInRow="i_drugclass_id" msprop:Generator_ColumnPropNameInTable="i_drugclass_idColumn" msprop:Generator_UserColumnName="i_drugclass_id" type="xs:int" minOccurs="0" />
              <xs:element name="i_web_pi" msprop:Generator_ColumnVarNameInTable="columni_web_pi" msprop:Generator_ColumnPropNameInRow="i_web_pi" msprop:Generator_ColumnPropNameInTable="i_web_piColumn" msprop:Generator_UserColumnName="i_web_pi" type="xs:int" minOccurs="0" />
              <xs:element name="i_web_ei" msprop:Generator_ColumnVarNameInTable="columni_web_ei" msprop:Generator_ColumnPropNameInRow="i_web_ei" msprop:Generator_ColumnPropNameInTable="i_web_eiColumn" msprop:Generator_UserColumnName="i_web_ei" type="xs:int" minOccurs="0" />
              <xs:element name="i_web_dr" msprop:Generator_ColumnVarNameInTable="columni_web_dr" msprop:Generator_ColumnPropNameInRow="i_web_dr" msprop:Generator_ColumnPropNameInTable="i_web_drColumn" msprop:Generator_UserColumnName="i_web_dr" type="xs:int" minOccurs="0" />
              <xs:element name="i_generic_drug" msprop:Generator_ColumnVarNameInTable="columni_generic_drug" msprop:Generator_ColumnPropNameInRow="i_generic_drug" msprop:Generator_ColumnPropNameInTable="i_generic_drugColumn" msprop:Generator_UserColumnName="i_generic_drug" type="xs:int" minOccurs="0" />
              <xs:element name="i_other_name" msprop:Generator_ColumnVarNameInTable="columni_other_name" msprop:Generator_ColumnPropNameInRow="i_other_name" msprop:Generator_ColumnPropNameInTable="i_other_nameColumn" msprop:Generator_UserColumnName="i_other_name" type="xs:int" minOccurs="0" />
              <xs:element name="i_web_de" msprop:Generator_ColumnVarNameInTable="columni_web_de" msprop:Generator_ColumnPropNameInRow="i_web_de" msprop:Generator_ColumnPropNameInTable="i_web_deColumn" msprop:Generator_UserColumnName="i_web_de" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="web_drug" msprop:Generator_TableClassName="web_drugDataTable" msprop:Generator_TableVarName="tableweb_drug" msprop:Generator_TablePropName="web_drug" msprop:Generator_RowDeletingName="web_drugRowDeleting" msprop:Generator_UserTableName="web_drug" msprop:Generator_RowChangingName="web_drugRowChanging" msprop:Generator_RowEvHandlerName="web_drugRowChangeEventHandler" msprop:Generator_RowDeletedName="web_drugRowDeleted" msprop:Generator_RowEvArgName="web_drugRowChangeEvent" msprop:Generator_RowChangedName="web_drugRowChanged" msprop:Generator_RowClassName="web_drugRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="i_id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columni_id" msprop:Generator_ColumnPropNameInRow="i_id" msprop:Generator_ColumnPropNameInTable="i_idColumn" msprop:Generator_UserColumnName="i_id" type="xs:int" />
              <xs:element name="i_generic_drug" msprop:Generator_ColumnVarNameInTable="columni_generic_drug" msprop:Generator_ColumnPropNameInRow="i_generic_drug" msprop:Generator_ColumnPropNameInTable="i_generic_drugColumn" msprop:Generator_UserColumnName="i_generic_drug" type="xs:int" minOccurs="0" />
              <xs:element name="i_other_name" msprop:Generator_ColumnVarNameInTable="columni_other_name" msprop:Generator_ColumnPropNameInRow="i_other_name" msprop:Generator_ColumnPropNameInTable="i_other_nameColumn" msprop:Generator_UserColumnName="i_other_name" type="xs:int" minOccurs="0" />
              <xs:element name="c_name" msprop:Generator_ColumnVarNameInTable="columnc_name" msprop:Generator_ColumnPropNameInRow="c_name" msprop:Generator_ColumnPropNameInTable="c_nameColumn" msprop:Generator_UserColumnName="c_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="c_search_code" msprop:Generator_ColumnVarNameInTable="columnc_search_code" msprop:Generator_ColumnPropNameInRow="c_search_code" msprop:Generator_ColumnPropNameInTable="c_search_codeColumn" msprop:Generator_UserColumnName="c_search_code" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="64" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="c_firstcode" msprop:Generator_ColumnVarNameInTable="columnc_firstcode" msprop:Generator_ColumnPropNameInRow="c_firstcode" msprop:Generator_ColumnPropNameInTable="c_firstcodeColumn" msprop:Generator_UserColumnName="c_firstcode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="i_sortcode" msprop:Generator_ColumnVarNameInTable="columni_sortcode" msprop:Generator_ColumnPropNameInRow="i_sortcode" msprop:Generator_ColumnPropNameInTable="i_sortcodeColumn" msprop:Generator_UserColumnName="i_sortcode" type="xs:int" minOccurs="0" />
              <xs:element name="i_name_type" msprop:Generator_ColumnVarNameInTable="columni_name_type" msprop:Generator_ColumnPropNameInRow="i_name_type" msprop:Generator_ColumnPropNameInTable="i_name_typeColumn" msprop:Generator_UserColumnName="i_name_type" type="xs:int" minOccurs="0" />
              <xs:element name="c_name_type" msprop:Generator_ColumnVarNameInTable="columnc_name_type" msprop:Generator_ColumnPropNameInRow="c_name_type" msprop:Generator_ColumnPropNameInTable="c_name_typeColumn" msprop:Generator_UserColumnName="c_name_type" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="24" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="i_dfmk" msprop:Generator_ColumnVarNameInTable="columni_dfmk" msprop:Generator_ColumnPropNameInRow="i_dfmk" msprop:Generator_ColumnPropNameInTable="i_dfmkColumn" msprop:Generator_UserColumnName="i_dfmk" type="xs:int" minOccurs="0" />
              <xs:element name="i_othmk" msprop:Generator_ColumnVarNameInTable="columni_othmk" msprop:Generator_ColumnPropNameInRow="i_othmk" msprop:Generator_ColumnPropNameInTable="i_othmkColumn" msprop:Generator_UserColumnName="i_othmk" type="xs:int" minOccurs="0" />
              <xs:element name="i_cnmk" msprop:Generator_ColumnVarNameInTable="columni_cnmk" msprop:Generator_ColumnPropNameInRow="i_cnmk" msprop:Generator_ColumnPropNameInTable="i_cnmkColumn" msprop:Generator_UserColumnName="i_cnmk" type="xs:int" minOccurs="0" />
              <xs:element name="i_is_solvent" msprop:Generator_ColumnVarNameInTable="columni_is_solvent" msprop:Generator_ColumnPropNameInRow="i_is_solvent" msprop:Generator_ColumnPropNameInTable="i_is_solventColumn" msprop:Generator_UserColumnName="i_is_solvent" type="xs:int" minOccurs="0" />
              <xs:element name="i_pi_pub" msprop:Generator_ColumnVarNameInTable="columni_pi_pub" msprop:Generator_ColumnPropNameInRow="i_pi_pub" msprop:Generator_ColumnPropNameInTable="i_pi_pubColumn" msprop:Generator_UserColumnName="i_pi_pub" type="xs:int" minOccurs="0" />
              <xs:element name="i_pi_dose" msprop:Generator_ColumnVarNameInTable="columni_pi_dose" msprop:Generator_ColumnPropNameInRow="i_pi_dose" msprop:Generator_ColumnPropNameInTable="i_pi_doseColumn" msprop:Generator_UserColumnName="i_pi_dose" type="xs:int" minOccurs="0" />
              <xs:element name="i_bnmk" msprop:Generator_ColumnVarNameInTable="columni_bnmk" msprop:Generator_ColumnPropNameInRow="i_bnmk" msprop:Generator_ColumnPropNameInTable="i_bnmkColumn" msprop:Generator_UserColumnName="i_bnmk" type="xs:int" minOccurs="0" />
              <xs:element name="i_web_de" msprop:Generator_ColumnVarNameInTable="columni_web_de" msprop:Generator_ColumnPropNameInRow="i_web_de" msprop:Generator_ColumnPropNameInTable="i_web_deColumn" msprop:Generator_UserColumnName="i_web_de" type="xs:int" minOccurs="0" />
              <xs:element name="i_web_in" msprop:Generator_ColumnVarNameInTable="columni_web_in" msprop:Generator_ColumnPropNameInRow="i_web_in" msprop:Generator_ColumnPropNameInTable="i_web_inColumn" msprop:Generator_UserColumnName="i_web_in" type="xs:int" minOccurs="0" />
              <xs:element name="i_web_pi" msprop:Generator_ColumnVarNameInTable="columni_web_pi" msprop:Generator_ColumnPropNameInRow="i_web_pi" msprop:Generator_ColumnPropNameInTable="i_web_piColumn" msprop:Generator_UserColumnName="i_web_pi" type="xs:int" minOccurs="0" />
              <xs:element name="i_web_ei" msprop:Generator_ColumnVarNameInTable="columni_web_ei" msprop:Generator_ColumnPropNameInRow="i_web_ei" msprop:Generator_ColumnPropNameInTable="i_web_eiColumn" msprop:Generator_UserColumnName="i_web_ei" type="xs:int" minOccurs="0" />
              <xs:element name="i_web_AZ" msprop:Generator_ColumnVarNameInTable="columni_web_AZ" msprop:Generator_ColumnPropNameInRow="i_web_AZ" msprop:Generator_ColumnPropNameInTable="i_web_AZColumn" msprop:Generator_UserColumnName="i_web_AZ" type="xs:int" minOccurs="0" />
              <xs:element name="i_web_olf" msprop:Generator_ColumnVarNameInTable="columni_web_olf" msprop:Generator_ColumnPropNameInRow="i_web_olf" msprop:Generator_ColumnPropNameInTable="i_web_olfColumn" msprop:Generator_UserColumnName="i_web_olf" type="xs:int" minOccurs="0" />
              <xs:element name="i_dr_id" msprop:Generator_ColumnVarNameInTable="columni_dr_id" msprop:Generator_ColumnPropNameInRow="i_dr_id" msprop:Generator_ColumnPropNameInTable="i_dr_idColumn" msprop:Generator_UserColumnName="i_dr_id" type="xs:int" minOccurs="0" />
              <xs:element name="i_web_pe" msprop:Generator_ColumnVarNameInTable="columni_web_pe" msprop:Generator_ColumnPropNameInRow="i_web_pe" msprop:Generator_ColumnPropNameInTable="i_web_peColumn" msprop:Generator_UserColumnName="i_web_pe" type="xs:int" minOccurs="0" />
              <xs:element name="i_web_iv" msprop:Generator_ColumnVarNameInTable="columni_web_iv" msprop:Generator_ColumnPropNameInRow="i_web_iv" msprop:Generator_ColumnPropNameInTable="i_web_ivColumn" msprop:Generator_UserColumnName="i_web_iv" type="xs:int" minOccurs="0" />
              <xs:element name="i_name_len" msprop:Generator_ColumnVarNameInTable="columni_name_len" msprop:Generator_ColumnPropNameInRow="i_name_len" msprop:Generator_ColumnPropNameInTable="i_name_lenColumn" msprop:Generator_UserColumnName="i_name_len" type="xs:int" minOccurs="0" />
              <xs:element name="_x0031_" msprop:Generator_ColumnVarNameInTable="column1" msprop:Generator_ColumnPropNameInRow="_1" msprop:Generator_ColumnPropNameInTable="_1Column" msprop:Generator_UserColumnName="1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="web_drugclass_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:web_drugclass" />
      <xs:field xpath="mstns:i_id" />
    </xs:unique>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:web_classlinkdrug" />
      <xs:field xpath="mstns:i_id" />
    </xs:unique>
    <xs:unique name="web_drug_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:web_drug" />
      <xs:field xpath="mstns:i_id" />
    </xs:unique>
  </xs:element>
</xs:schema>